Problem Note 42043: Cannot create a custom filter for missing dates or datetimes when opening an information map in SAS® Enterprise Guide® or the SAS® Add-In for Microsoft Office
 |  |  |  |  |
Beginning with version 4.3, you can create custom filters when opening information maps in SAS Enterprise Guide and the SAS Add-In for Microsoft Office. When filtering on dates, datetimes, and timestamps, the value that you enter is automatically converted into a SAS date constant. The date constant (for example, '30Jun2010'd) appears immediately below the Enter a value box.
Because of this automatic conversion, you cannot filter for missing date values. For example, for a datetime value, if you enter . or 0 in the Enter a value box, your entry is converted to '1Jan1:0:0:0'dt', which returns no results. As a workaround, create the filter in SAS® Information Map Studio, and then apply that filter when opening the information map in SAS Enterprise Guide or the SAS Add-In.
Click the Hot Fix tab in this note to access the hot fix for this issue. After you install the hot fix, the custom filter feature includes the operators IS MISSING, CONTAINS, and LIKE. The hot fix also adds the ability to edit custom filters.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Add-in for Microsoft Office | Microsoft® Windows® for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Enterprise x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Home Premium x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Professional x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate 32 bit | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows 7 Ultimate x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.3 | 5.1 | 9.2 TS2M3 | 9.3 TS1M0 | ||
| SAS System | SAS Enterprise Guide | Microsoft® Windows® for x64 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2003 for x64 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2008 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Microsoft Windows Server 2008 for x64 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Microsoft Windows XP Professional | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Windows 7 Enterprise 32 bit | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Windows 7 Enterprise x64 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Windows 7 Home Premium 32 bit | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Windows 7 Home Premium x64 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Windows 7 Professional 32 bit | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Windows 7 Professional x64 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Windows 7 Ultimate 32 bit | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Windows 7 Ultimate x64 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Windows Vista | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||
| Windows Vista for x64 | 4.3 | 9.2 TS2M3 | 9.2 TS2M3 | |||